Previous Topic

Next Topic

Creating the Name_All View

The Name_All View is a pseudo table, or concatenation, of multiple Name-related tables. It contains fields from all joined files, as well as all related rows from all joined files. An ID that does not have a row in all joined tables will not appear in the view.

The Name_All View automatically includes data from the Name and Name_Fin tables. It is required for all special pricing and should be used as a prefix for all iMIS source fields instead of the actual file name. (See Defining Special Pricing.) Any custom demographic table can be selected for inclusion in the view.

In This Section

To create a Name_All view

See Also

Billing Table Maintenance

Overview of Table Maintenance

Setting up Customer Types

Setting the Billing and Reminder Notices

Defining Special Pricing

Special Pricing Examples

Defining Prorating Rules

Setting up List Billing


ASI logo 10.5 Production Release. Updated 7/14/2005 5:33:26 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.